package com.fz.mapper;

import com.fz.entity.Shows;
import com.fz.entity.Situation;
import com.fz.entity.ZhuanChang;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * Created by Z-C-Y on 2018-03-07.
 * zhuanchang.jsp====专场
 */
@Service
public interface WebZhuanChangMapper {
    /*得到页面专场的轮播图*/
    public List<ZhuanChang> queryZhuanChang();

    /*得到导航栏中的字段*/
    public List<Situation> querySituation();
    /*分页======查询数据库的数据的总数据*/
    public List<Shows> queryShows();
    //有了pageSize和startIndex，就可以拿到每页的数据
    @Select("select * from shows limit #{startIndex},#{pageSize}")
   public List<Shows> queryDataShows(@Param("startIndex") int startIndex,@Param("pageSize") int pageSize);

}
